SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 238570 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 238570 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516090,761155,88009,1042975,34135,663343,229605,158264,817654,323363,395868,645007,741528,624762,434521,439181,561806,823924,335066,494565,926718,351672,390408,941245,620717,901827,506009,715225,732005,571908,530929,445343,441957,997749,463702,700429,210989,998909,80302,310052,920455,732033,379530,110007,981160,545818,791445,325507,37080,56044,859788,144726,701354,554342,594430,769329,324220,400030,738904,1024208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 238570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 238570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]