SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5300 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5300 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672057,376097,882168,40042,280546,412977,385108,629876,443197,693558,469519,107634,523930,9827,433937,572965,573963,372039,254073,245817,44984,468639,654892,917068,795739,301125,112044,707236,53692,141946,169622,574869,320539,387836,604357,949341,30389,807925,485833,140839,1047411,529920,660854,299783,460036,374518,41882,39072,660754,373182,150900,826667,130734,204510,106803,77535,117342,394386,774531,906627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]