SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34114 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34114 [ RunTime:0.001386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006372,436256,601613,1028808,831467,320894,843937,173517,201211,326558,895777,15923,758001,800000,1026764,561098,47807,432251,60385,856270,903714,241110,1003356,535647,219450,64638,719601,165888,477489,818377,476045,761943,143851,692318,177656,414935,39666,322528,906871,809534,909545,36658,785190,655565,720634,1011358,115588,514976,296081,913496,885124,234397,462057,381549,802994,716812,82101,384473,901091,450630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]