SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108213 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108213 [ RunTime:0.003853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8709,778735,926687,186086,615296,414885,487753,583285,366281,368412,19465,585595,211730,213627,722341,680307,345091,699238,462048,1039472,852095,1007033,163138,498522,251058,273456,111703,975310,199128,790370,801154,947713,36055,196699,779791,331724,407054,342351,472133,405569,51913,483006,283756,605611,781284,742644,155562,820380,77575,499927,619426,499937,42344,331832,818794,195195,921478,551759,692050,349401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]