SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814739 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814739 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556125,1022101,866224,1037880,164022,237681,1010835,478145,994042,854136,510939,507325,649397,158755,220808,140465,991268,362289,202494,419324,235474,881982,803226,961737,997757,324026,680991,1038732,736618,640475,683295,410512,162061,107342,121833,347237,303465,621192,39434,886251,705284,1037581,154089,1026893,648883,930153,736977,509287,617233,400325,290749,509300,649328,543130,477523,875901,392975,763097,738821,868066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]