SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33220 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33220 [ RunTime:0.005541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513780,840139,792868,695411,471919,498163,497997,408784,34491,840138,110844,623567,659595,1044063,690998,176439,645979,141213,204935,754972,165625,274718,221813,860163,689170,495756,398190,457881,872049,55004,499713,1005247,767882,82843,817222,457125,52693,376836,807300,994509,571534,422132,1042538,82206,905345,657348,639070,184897,478720,879956,1019680,433759,546804,302054,413666,313925,994112,417724,24055,237473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]