SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022687 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022687 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248797,608430,531421,114275,33941,894447,925310,425663,1003972,789188,774265,812129,622412,745242,762867,890934,528184,877307,744728,973140,924180,119307,660020,149507,986543,1020185,667208,808808,62901,347761,504840,859643,406600,951155,521049,390434,580947,309311,805121,933889,164037,162631,651518,243592,622038,214686,93621,41704,944181,64182,178598,93069,132154,29690,15068,1024490,1040048,221168,766085,462577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]