SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525576 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525576 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500477,112498,738850,144623,119400,492811,621663,20769,443483,338007,1016725,490926,707340,199701,342195,836936,991601,675991,656482,321277,55728,735779,555386,546642,1035222,903226,371521,271964,487547,99882,628316,291636,659818,793994,604641,651357,732086,282928,541346,679932,126694,958244,641212,801774,635141,78464,511525,742163,625234,229623,297194,209169,357276,118142,700417,695400,460132,686907,344077,379251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]