SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29103 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29103 [ RunTime:0.002366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176636,224824,515909,250118,9958,66299,138445,55195,904738,819529,928970,695491,1041386,253920,979943,103604,193132,579233,1037404,202848,421223,731940,1042166,990852,824405,609373,15790,545596,734385,132970,684688,810513,988907,621711,122417,239233,516659,342505,917453,146531,961843,881999,271115,485862,406960,168053,767295,313844,214292,1020645,659999,388254,61206,716141,156374,413918,5293,837079,322411,1030159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]