SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164413 LIMIT 1 [ RunTime:0.001542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164413 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900520,1000060,843147,326312,162888,620819,1005574,264960,673300,151372,26453,380398,252013,916108,282655,216161,1207,323749,594480,834393,801325,127570,356825,556505,330167,518270,413354,897851,708839,939808,901613,468264,130755,836685,476,521557,452102,281606,596293,210799,78653,385161,366446,661802,998126,892031,179168,596736,298165,669104,234870,510042,310634,350217,774026,294495,504034,167892,105752,199001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001053s ]