SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001953s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319216 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319216 [ RunTime:0.003590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405148,662469,1041283,40613,799042,920985,444122,265684,806880,128938,648292,465885,591175,914922,1020838,440178,886293,657726,722072,458952,19468,894906,111629,582754,502837,583032,745886,672160,253724,817452,536089,125152,605842,307115,1040855,628731,630865,991123,1030319,307824,736070,489060,16626,864866,209975,906343,311746,460324,439353,550134,288134,99816,684443,170536,834026,635447,285052,941338,256008,149745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]