SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477413 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477413 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556035,503109,31904,772412,981822,37624,415037,707232,488073,554544,611192,330196,999238,19068,448542,720697,631607,222634,605309,129168,579794,930549,70600,860227,469531,700886,61977,945725,138581,41132,149815,95361,827603,647070,523884,487893,61532,450656,632110,463367,700039,438364,258348,1047167,352498,846095,609603,580979,181865,64590,80651,857690,240877,855253,214747,295454,570404,284670,9756,816532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]