SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107573 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107573 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902940,1023382,49505,734422,23118,542,175935,862288,344496,708305,53131,468796,480427,547082,242476,112098,359321,876352,393841,156027,56949,561275,465796,748539,699412,496639,241406,416673,384800,231581,152059,715961,116090,568857,27002,72937,831829,474294,594145,128600,835919,325633,700373,552642,288284,506999,136621,498570,365276,304700,471693,1013595,225020,252909,173231,613643,549971,768337,221701,561588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.023230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002203s ]