SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43203 LIMIT 1 [ RunTime:0.013420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43203 [ RunTime:0.004146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552730,889806,860703,52452,797407,129531,568206,75234,662102,583738,493275,184104,469425,224999,773851,244480,492345,674291,72129,675422,64961,1017378,416728,903969,686393,151435,606790,570316,322319,468253,886010,354928,1024744,725950,238037,557346,137111,976997,692898,222815,33662,555050,639785,339396,1017797,396181,1022633,274826,1048323,368597,114612,940502,63639,721604,53433,353506,3139,1038093,835775,998549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001750s ]