SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419376 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419376 [ RunTime:0.002188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430012,1039062,765867,438933,717814,851004,79695,89455,53438,478559,741352,24214,71044,450167,981889,568692,136145,47896,683534,567865,802839,40593,666481,218451,175244,224123,293850,998167,66143,829909,85210,283696,42258,67156,282727,853836,542759,555852,774198,861359,1026804,366042,535255,518010,831084,375823,21699,660136,866034,590995,564902,625000,1014930,943815,912495,515778,275155,230594,938964,67318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]