SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398730 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398730 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930543,846523,510184,144650,967557,735511,1037499,456588,489068,872377,166205,459506,1026239,58476,450026,840516,266421,410505,367482,727807,489901,532004,260934,116852,406769,127868,510989,437456,160073,595042,777742,317485,507693,582100,751323,407982,434069,1041360,42497,915777,72773,168154,765319,468480,65937,1028468,556938,780757,850678,750500,771978,169458,399181,1409,972816,70363,564574,10458,97382,55086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]