SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549810 LIMIT 1 [ RunTime:0.002601s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549810 [ RunTime:0.002768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777413,440231,1022040,515284,465382,609375,4610,758382,110076,618257,96281,904228,78479,823976,510309,254724,493884,191111,519178,617687,650655,833443,178776,721441,435211,1023519,229324,658104,726101,604384,320220,155311,63828,541737,318264,510241,582324,864552,540444,873809,749576,190874,304470,613851,886957,621586,466085,576847,724101,613349,887831,878795,152900,227482,550182,565427,138867,511791,816055,762555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]