SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002566s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029854 LIMIT 1 [ RunTime:0.001040s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029854 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784305,731888,388882,401439,980970,629090,10343,897928,310236,272782,168917,392189,897615,815846,820073,847855,528680,266924,113672,162716,1046972,8327,706069,132464,805394,242916,228574,557991,42344,11563,149592,748649,177892,406054,289276,64847,509111,943371,979943,665702,719512,362804,704826,659761,821050,83065,1031391,924378,665309,104787,490365,486923,642304,929544,728219,20179,918866,325857,674074,416295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]