SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021078 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021078 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142341,684531,338327,437818,651465,809593,246135,394730,276887,852663,777942,610176,773928,750458,584437,160204,374226,820417,11211,756170,492709,765682,653655,791391,1029794,930231,670471,771480,873746,821070,463569,718277,334718,670613,645170,166878,721932,24730,912130,210687,404760,757923,456100,274833,534242,676338,1019526,322733,987321,145332,596058,144594,970312,872950,659492,727711,652254,26013,87699,223221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005006s ]