SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541007 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541007 [ RunTime:0.002455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175677,802530,443969,348774,805433,901733,432277,60568,32354,466233,434960,174908,397087,449453,402498,605724,746051,285556,737379,665178,721188,399006,470882,421536,476833,957125,340601,577742,6569,433544,614103,25037,625747,729685,798467,501383,859130,492848,16165,578796,339201,814168,147685,446242,913870,288112,287915,389860,211904,1035503,696985,11390,785383,889018,103679,620578,623582,403231,162209,995008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]