SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004975s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022223 LIMIT 1 [ RunTime:0.002213s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022223 [ RunTime:0.004424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592540,78469,152042,171539,153924,458716,888780,997957,572608,793566,240350,749572,946346,479825,296097,761,333168,253691,515277,702045,219381,159992,40935,760100,340327,785570,415559,437133,644670,171545,1032805,765340,787652,404968,869464,294085,404165,441534,292862,996348,1042689,27969,348575,741620,637434,636333,28208,678585,911683,788829,293117,102960,798854,580409,150399,521006,762200,563043,726943,385048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002531s ]