SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003859s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392007 LIMIT 1 [ RunTime:0.001146s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392007 [ RunTime:0.009849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16439,907559,599688,122564,554044,701534,223858,26343,347258,415355,271200,699444,1012970,380018,667779,925326,380499,79657,931612,47403,978551,464014,461609,143639,972696,1034170,813929,765714,398211,587158,187812,617209,100364,967428,368415,354131,788215,910000,663576,128931,837776,248992,294895,818930,475593,808006,847056,176849,736104,215623,747127,819938,398882,1001032,208216,329142,425185,1001748,733149,1029533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]