SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005391 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005391 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109076,1044699,721024,843616,151863,930020,837993,304923,705883,860452,907375,525712,280416,146277,433860,162465,427265,1025387,960457,109795,711817,406019,54138,1031752,817496,491000,740248,352762,338147,124061,1017418,129376,625922,334975,158233,954420,311466,796323,58269,367518,810341,56952,304038,902108,13209,995236,192384,378231,264227,574691,254512,700074,369480,93630,976169,111945,762634,508748,192005,838897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]