SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527641 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527641 [ RunTime:0.002069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591370,959917,180699,161664,665057,894240,275667,314337,862651,442837,381008,610056,405117,61649,590475,286125,166048,365437,123071,847032,166566,281842,158686,361189,663332,17339,191648,295093,152677,785831,226883,642867,39169,1127,454936,361672,746387,530621,907503,635686,861387,1002247,313219,572714,907614,227689,952045,186998,394351,891138,654734,796377,73239,848645,729286,643466,444340,424206,408531,852727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]