SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104459 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104459 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248318,838486,581786,565802,955750,459211,293745,778301,60554,604442,1001111,58689,946343,726506,532178,914872,931593,437730,1038289,680162,572461,251450,769768,50150,605555,951805,278298,20975,849733,424594,955941,483662,727869,895998,896485,441557,939265,648339,320531,359544,361273,467557,621949,615498,280695,284353,953982,723848,306790,25742,982987,856891,822083,371505,525669,118449,998249,132092,365336,1041056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104459 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104459 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]