SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017661 LIMIT 1 [ RunTime:0.001663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017661 [ RunTime:0.004035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008302,944450,118867,870493,131481,750556,334099,255933,764421,123874,356381,1038700,583559,250079,907221,466955,831405,879516,3353,818959,344033,909050,302870,174472,534615,103174,22410,443034,353874,787289,61620,992149,572365,1016023,517840,855832,19717,332442,294808,1036975,216745,823629,475285,946597,957412,290686,328550,402735,1021545,378705,919533,710121,735142,168270,128889,318910,730611,951351,272178,528020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]