SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338260 LIMIT 1 [ RunTime:0.000738s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338260 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33547,56807,1004778,839238,655488,642741,922583,162761,612959,101415,715141,183833,353138,406144,529270,871738,322553,30742,862355,508555,132340,895112,138222,1032988,779651,141383,113199,113185,305409,78583,1009879,898752,269571,100395,420488,354363,113631,652712,411585,180339,1275,721477,303398,871018,484712,527552,378883,692814,539953,983768,682120,977853,546369,445353,354172,143811,842585,492475,977435,191255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]