SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014226 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014226 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87880,411667,510904,897142,809342,89363,604412,563782,158355,634763,363611,22502,1008056,794205,447966,679887,1029900,1019034,181569,302510,163799,545808,757548,331535,260310,537811,55748,923568,813489,284852,270727,74213,128231,776956,820422,542094,348607,470604,22472,184330,896472,842944,851937,826327,1029182,883338,358337,302896,954919,647659,494690,693138,1038274,27565,526687,175056,179014,662675,571614,485072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]