SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331401 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331401 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419467,874235,1012104,673822,853234,401201,574401,352387,355409,694085,794391,615020,783711,122110,827968,123078,470868,14639,350008,769880,306169,879445,1037878,377339,630588,897323,751232,195670,27375,724589,1023361,913728,428086,240348,386903,602182,165964,486617,354453,478062,212252,213781,878835,826879,99713,253783,100538,726818,963273,130405,745932,196512,740447,44328,373522,2440,772247,626185,1016223,860732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]