SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037055 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037055 [ RunTime:0.005506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112964,793851,186137,520592,911274,257827,230073,245865,113592,366503,141095,810540,99964,344316,403684,10982,932936,10439,378109,702235,400977,386627,46304,930449,355181,418512,1017196,957177,646965,475013,624966,240785,161366,843864,485038,683051,540057,780837,936499,1005536,177455,324059,913706,1010772,294988,596177,1010616,138439,243472,553773,397065,370533,520437,243642,84211,74182,481609,1002603,989045,640238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]