SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449052 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449052 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419655,99401,267040,768494,322390,301943,876921,854809,44329,50144,936216,1013979,288124,288357,41978,652557,855350,819732,65151,227382,329131,502984,462930,743374,298007,664853,800543,442854,906726,691667,865947,510283,535653,392093,201129,1016551,562919,450354,802790,693376,1035631,272021,831049,784373,164790,769320,453558,234878,741089,836008,333967,198825,765174,592384,774109,633372,501979,539778,893809,3184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]