SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387540 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387540 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39841,106242,644179,481076,347994,155548,570588,656837,500501,342229,827389,710418,540940,826728,136414,535677,628102,848566,856984,490930,510195,147182,872347,144200,979231,1007368,816936,234761,506104,398663,335869,542846,628691,32738,689605,810265,293516,928498,71153,577866,476067,521698,233036,1007411,908118,249900,428813,967122,257583,194029,937976,282094,962952,258149,151970,226546,526342,344909,996786,298958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]