SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434039 LIMIT 1 [ RunTime:0.001310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434039 [ RunTime:0.004032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470340,365977,582634,57348,845269,764554,392717,353061,585073,666322,401898,380211,464156,425612,102660,221482,454947,218818,19543,417413,437457,794136,242815,618997,836015,221928,98313,422869,2636,745474,548874,27444,149242,29066,921862,528181,349015,475613,44614,381842,457438,802149,751793,997741,397218,521813,959515,631470,428168,58502,997977,735613,444461,602264,601767,43084,622672,424958,303789,796313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001134s ]