SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560300 LIMIT 1 [ RunTime:0.005204s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560300 [ RunTime:0.002551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492354,72957,254310,246572,888107,451467,890873,39437,905581,113911,753923,320151,474666,487669,643067,589665,305079,30229,973545,159633,797775,98434,967400,953103,255776,108638,215178,447575,8143,334043,217562,809232,122719,703043,64209,998506,496170,513318,676015,637905,342401,726441,154432,431790,591750,94729,812131,428171,609675,693541,974869,749524,911407,701610,66146,458454,286206,262638,930188,232858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]