SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486402 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486402 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705762,448755,420747,1008363,963918,1037187,1043878,972558,542004,96156,75514,596837,265629,967851,52696,258174,280686,870292,191812,825178,782593,639993,345004,242901,990697,690507,1026437,179324,839644,483913,682570,324565,952987,1038073,129436,822944,563956,390773,697980,813547,1037264,151633,223069,54157,200794,954796,564084,85844,892961,1024185,888995,33608,458841,552436,216097,492263,346608,862890,129363,122294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002422s ]