SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480922 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480922 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82145,682852,345481,200493,321883,220229,134429,440708,592584,662129,286951,738932,639963,299987,983683,99210,440394,1016123,388713,76773,491539,414670,14816,789774,61584,359639,863299,199013,289078,520963,756434,145857,1002201,661078,557447,155487,534356,331067,738597,879169,355775,462439,937055,161170,140965,457859,1020027,632235,690108,340969,543076,106815,1012910,59241,37788,236119,576635,958280,684378,338019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]