SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 702413 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 702413 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303679,48728,710160,481134,250474,1042580,489957,30975,356488,786848,583775,891329,1039083,716768,674018,636695,817492,540147,250652,210988,383079,606758,346720,155690,90318,712861,743860,201996,516723,492745,562640,886776,222337,1028871,737315,149710,457611,645659,996129,286172,755035,523747,61293,455825,384667,351550,881171,563835,328433,956960,366626,600262,249720,661675,218338,538189,419944,1037896,482718,639035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 702413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 702413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]