SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342181 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342181 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838776,735511,1021406,985083,206060,988821,732980,594848,876319,1048917,500090,536597,839054,58975,899548,7272,320263,445405,517144,820448,877285,192146,334775,379822,737730,741487,406602,906669,938491,469607,367205,608290,110115,349662,752403,95574,237228,500782,88780,864871,539534,1037666,104469,728832,375706,255513,553819,565624,389391,58645,308587,638742,953359,16416,194498,530689,399126,235247,263470,491677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]