SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 959800 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 959800 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955234,240669,187157,1008665,60994,463360,195060,515447,288247,57383,106290,542139,910682,209036,464364,998556,779697,938731,1048718,783894,732839,757272,79590,670294,595108,24894,820783,807424,319762,180543,1012669,217254,620714,523003,210183,558334,144355,578129,690703,395218,914715,171009,196121,783476,153382,171711,546213,295171,1014835,813392,727850,498138,804248,263578,652733,102846,140,79494,111940,947829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 959800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 959800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]