SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545860 LIMIT 1 [ RunTime:0.000705s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545860 [ RunTime:0.004037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48225,1010583,864197,186603,946437,917451,976791,968953,985322,644445,973746,289713,25661,284542,8308,510370,1010081,257385,555695,390005,722491,182048,146592,834459,710221,881885,764441,521343,59974,935385,927673,846790,738120,467461,379163,393971,567636,807727,400218,861531,1010981,7091,550011,1048202,969781,577048,687247,1038675,352193,128038,73023,538525,69096,234956,671704,801252,320923,769362,256946,660245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]