SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195003 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195003 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750774,691879,559482,358622,848869,1045068,354656,164734,44250,470199,1023503,442659,187302,731680,869939,703413,246461,987814,291843,232251,723740,308921,253621,220895,386095,626549,418374,943527,647886,918447,99796,370307,287528,1032984,332429,749497,209876,863913,627087,884846,337498,48596,987708,863904,634495,339534,1022785,142175,778279,834854,804018,185542,260265,916365,219375,16324,316848,68316,1033695,224847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001861s ]