SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048831 LIMIT 1 [ RunTime:0.000931s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048831 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107778,811862,821947,1029103,687183,278158,268424,994008,895639,623694,937595,335333,366976,943446,1037599,83662,733965,788613,834161,316348,115742,295381,845918,1017193,65555,548136,251666,1044753,1005723,536398,6722,119042,587900,520292,1003800,835203,271131,871197,776966,614322,482781,696301,950315,533174,2647,587928,743998,1010671,201639,53244,144300,36731,75158,229428,441387,112199,87869,694521,717799,443507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]