SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534400 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534400 [ RunTime:0.003343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169488,122607,257480,392685,816514,336475,279459,964284,283419,496819,75111,241497,246297,437281,431508,683499,149905,317100,141296,742761,962008,861788,139336,320108,822087,798406,690826,784686,511542,538516,667254,143726,573928,823187,462133,973173,685673,761211,125315,864105,559375,927023,826130,891590,715180,446937,1033736,554148,288951,307572,532708,78546,749598,258187,54310,635577,1041715,708555,540064,542266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]