SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415735 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415735 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121721,362025,778573,921466,551913,849483,943514,1002496,248234,894833,334537,574983,141909,505590,443887,801764,772693,257717,120184,104160,681132,707825,921902,608189,965747,781701,131314,207652,592259,543657,387958,85697,743430,554838,1000408,5422,934058,24240,433396,240183,178594,235900,803203,929118,827193,41820,573878,773039,89955,104165,864299,310664,973400,62427,359885,272975,60060,83052,729474,271542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415735 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415735 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001202s ]