SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001256 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001256 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118515,764470,545846,517137,450907,759276,794754,108307,980580,284797,849470,616708,800359,603253,101513,443525,729019,300072,267811,31169,214826,81538,298990,213740,693885,721083,119513,843597,233858,49757,1003677,890637,588207,879821,601145,210039,8296,781406,15719,569686,405599,655361,919579,326571,499974,888510,260416,97186,834988,720958,2160,498238,717739,173716,98457,1036785,224690,495869,6984,585904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001256 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001256 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]