SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000905s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26544 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26544 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624052,655445,126384,1739,147167,40698,523265,770746,44660,990133,1005553,363546,91683,1014503,520927,1003001,211431,234201,323171,322261,248635,737420,407522,843920,218527,77631,194728,117025,203924,636118,526252,565196,906274,264439,553123,758530,176024,71633,131850,133925,972337,953879,700112,576963,491841,909854,995901,539194,955267,431542,583602,821902,954085,365182,140121,686093,406513,387458,366783,740995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]