SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985191 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985191 [ RunTime:0.004075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229586,787562,350107,1040040,318404,238909,5016,730604,572430,754613,299962,918577,265263,322917,1014644,590908,93150,880998,189724,169708,857601,921095,178499,534077,667136,142802,966877,763025,781854,19130,173690,879442,632554,311027,890338,1035381,17743,622621,334580,578027,501507,414166,252129,123109,136381,274547,649773,491215,404521,10564,331158,844160,642023,527494,431748,627719,1043096,442387,404360,716727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]