SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410622 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410622 [ RunTime:0.003069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965267,287086,919118,688458,910068,503083,534177,30438,560125,121846,593441,469672,303955,664864,499946,122660,592513,573693,671329,345484,842532,1002517,159955,939077,749840,752726,399023,367365,739154,981108,75820,187047,291321,824132,208613,852487,157047,600766,533877,266214,108532,1046355,177230,250106,951671,58728,287063,421024,304913,802929,747919,135892,131093,634890,900127,595788,128288,82726,735423,126721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001358s ]