SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439599 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439599 [ RunTime:0.002223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568583,908965,752365,384519,498094,171960,809646,1034941,589414,94872,56117,350096,207140,739457,292808,473925,813229,88595,500705,220403,847584,865504,672951,702623,895813,231813,402833,244799,1048412,768233,957415,1035213,780505,519544,271044,805139,970276,985345,109408,937501,408390,616642,98822,338023,77749,577149,171841,649556,957695,839310,988697,928856,449875,206064,597160,261231,742569,904570,520809,281732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]