SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50708 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50708 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764988,617483,484711,711246,431136,820950,584100,58345,610859,481102,97146,238166,52187,473254,417210,555824,476489,271814,623807,340186,388399,690283,593473,841174,978563,202213,179821,572684,927361,396250,316334,592594,909223,917821,158203,359792,746453,190709,360243,1017695,876915,968145,789144,346975,347042,128466,945790,982038,195268,370249,713374,23330,1039102,142096,292092,269275,654583,233896,173410,556537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]