SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319386 LIMIT 1 [ RunTime:0.002812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319386 [ RunTime:0.003965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241965,587127,800438,784141,543975,437356,895753,188180,46055,503829,647074,427517,12393,392838,284612,19282,53303,298894,240637,807109,994853,424678,249211,801155,541344,255098,405166,356281,825660,451393,945490,232573,240772,356162,188151,994302,879356,137808,111641,236119,491063,591086,740891,553590,447254,617635,687230,832899,308813,495749,43942,940327,520593,986155,629246,596016,901193,813681,982253,581415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319386 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319386 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]