SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299276 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299276 [ RunTime:0.002927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407973,572988,738129,28623,919695,1000223,248476,929107,647378,496250,38661,991156,1007839,702128,316571,123113,240571,509562,137539,605492,539421,942340,1012506,300141,41088,784965,518952,126084,232131,385490,190271,347975,417504,907028,926712,987189,946532,244350,438606,757200,884749,792477,201385,818997,483688,789335,149211,624393,572187,412965,540926,608328,376970,936432,700740,519376,1019873,629301,219943,989880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]