SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048742 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048742 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220986,749858,343424,485093,1001012,669632,987609,64259,292433,11022,879359,134861,7230,627331,347255,501647,790977,982590,814017,679,263360,380928,609860,195181,59942,308669,909388,72155,940929,971085,435154,480632,818096,766718,730629,743675,689707,799921,67311,746180,87857,750894,725987,719673,895507,305531,239830,440618,773094,41848,25719,123462,935274,14593,894084,929729,287084,242704,174351,798448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]