SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450977 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450977 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427187,123460,57230,439398,788199,531596,385146,816067,495556,849302,512948,11853,752572,1024590,643339,294184,826331,25648,222536,919531,363525,834357,1040357,986220,252795,326593,113882,307236,802900,879700,613714,30252,78754,57946,458351,287410,268988,222270,798080,487145,118275,379999,49063,1039984,547708,762,183909,398413,1021332,803264,235476,899478,184037,714354,174729,910214,21840,298173,328403,291691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450977 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450977 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]