SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525486 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525486 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73610,774890,297740,1027283,247566,50997,19301,390534,547101,201863,443038,185803,114288,790508,555925,22210,17024,645371,783187,999719,99105,865523,116487,21079,783618,188945,394278,791074,253695,51709,50123,343601,389022,36205,81090,1038303,47860,250587,271569,117735,99802,466426,920554,695846,164907,683745,52580,539469,540877,1036009,372778,898381,314890,360188,986153,776937,213402,33748,707389,308500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]