SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505363 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505363 [ RunTime:0.003537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252501,896487,332949,74198,616460,638079,667840,119616,1015116,938838,1006840,145286,766408,682412,161411,646198,385263,109929,380380,823025,530565,672910,754009,819563,380275,664355,304163,500742,482502,857551,151728,31344,39956,782476,70200,228557,417040,78062,935234,132711,902936,306495,327816,1023041,723749,197705,650932,929396,667076,744736,678891,997000,15304,792091,713673,664832,305853,802,889512,28498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505363 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505363 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]