SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80401 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80401 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155134,130695,732832,702294,577154,312932,856803,13206,530419,578469,65173,453759,244738,702778,69514,735590,451374,1014251,956351,279766,707239,752339,1030110,361747,789499,491017,16460,273029,617255,537501,45812,173592,856109,843156,685206,485225,1031989,669232,599514,546187,628039,536538,217829,524789,35037,217116,102644,772389,605069,358122,505512,328273,384244,388487,956462,583412,848146,884418,277279,189042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]