SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 152091 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 152091 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67093,154788,230842,676087,74123,422913,893593,616270,326242,252404,8966,62107,565854,513218,1039373,113672,715187,255821,802922,1047967,887049,288282,118806,781003,389099,783444,674141,740667,605012,331966,418086,333960,616483,593841,931602,726572,1014042,418628,274803,834551,856303,610211,971047,127214,262500,479801,561425,152691,829151,901199,66616,528819,920958,60211,208925,1009487,845985,892430,15460,794803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 152091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 152091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]