SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535067 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535067 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903053,480606,141174,78443,140544,754059,58857,440204,673868,983670,506601,918102,999161,928510,51008,342305,688118,801208,518316,168172,446304,524728,698771,537758,311768,45781,927686,498266,861972,440309,220133,341357,567293,117693,973955,164729,787149,405586,712307,190173,750881,71425,206297,494634,900938,688717,929668,179546,990740,315730,196768,859159,698154,438838,477962,413680,794632,267337,883072,409679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]