SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3473 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3473 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180219,975903,267980,152240,243306,913594,419543,110048,842544,547460,427067,781036,433650,286928,41522,48387,388318,306072,659082,55260,520937,970433,127669,216951,205796,160290,411437,491077,299795,329930,185762,592767,608013,447655,63473,22352,205761,734143,963117,671346,18711,363023,853739,542567,1047150,898292,952026,334705,594187,623676,809329,916,733577,163597,229575,375251,76604,983872,996245,748468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]