SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294489 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294489 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54022,421837,601224,453476,287521,766398,691339,425047,176786,1004102,121323,1035949,850029,507073,1021782,596832,760407,900509,236544,770366,58666,157152,985658,688710,603476,776333,1034185,941592,985500,141436,739720,745155,569578,512768,932064,434199,446323,875411,598078,796749,284204,611072,593714,564405,674591,194234,141320,659343,349151,906638,354072,604355,653984,776355,967295,946676,818096,906162,356194,150430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]