SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523801 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523801 [ RunTime:0.003773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510906,88202,583074,893295,871243,156573,416794,354197,549505,777703,902461,112245,550696,363580,105142,409098,167361,570316,847284,816056,177472,1012419,289578,930286,294258,520351,666312,612621,61654,632373,300356,425795,825144,975029,459445,370911,730828,430684,117777,481496,999675,568810,663873,246369,737803,39912,492364,938960,596210,836094,949937,611645,677181,369918,753849,360265,279837,405607,211334,566617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]