SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508118 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508118 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203015,488693,15013,278832,225948,691539,746671,319524,525414,869932,233514,109645,851674,164365,660500,1004013,732030,682739,469231,946292,920758,787089,946957,212596,131173,697340,826799,585005,640384,914355,995334,950719,295447,269113,441296,108838,134916,694011,866579,37454,5078,133459,58678,925882,20782,482861,40436,953242,608372,256311,436500,215141,37190,553308,251000,373223,432846,501127,352106,655914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]