SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522860 LIMIT 1 [ RunTime:0.001212s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522860 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423136,967004,121661,126013,295499,661787,60718,896204,994539,556545,511092,210959,892334,580798,1013238,85519,604583,950168,312667,257707,303692,489937,449067,24993,936451,330475,732965,727538,627885,890806,108602,543208,690822,565218,472365,506203,262931,678298,800003,797429,453542,519879,663989,481180,767828,423892,951755,711006,100585,639495,921428,272004,1011424,385784,304078,624022,704885,725823,395429,906055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]