SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20407 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20407 [ RunTime:0.003854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405688,284988,376799,107874,1039225,746067,156807,53268,187009,206910,208578,610203,395730,32813,1043788,171613,679852,997627,426535,471801,381355,905337,978611,924186,5553,749373,64302,890112,310386,113976,618643,243555,318375,270358,448763,59808,500331,1000316,861294,781003,936420,891071,290982,119881,344152,416804,463149,451031,236972,350949,531893,1019464,1050,621442,353084,620327,809661,481875,981161,258312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003945s ]