SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671971 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671971 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30654,260618,385176,955824,201651,33967,721963,839816,515017,1020204,356449,406098,823390,410929,166786,333705,732865,101049,503667,54718,962987,579613,449818,176738,971777,184366,53517,923943,922013,344904,239027,413403,189370,477115,346327,897857,84231,680674,871714,982703,745732,77622,965838,120170,990795,413604,776660,788932,907787,520395,250262,709719,132374,734124,619737,64108,108544,687837,227671,658331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]