SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450887 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450887 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678804,29127,333409,772018,444679,95536,312005,791350,171403,536045,956671,247289,509582,147930,210447,786784,410408,1040767,304940,547580,382838,205132,165953,395980,465399,879353,793440,778876,537445,44541,631483,173612,451621,78562,209030,812071,803468,772172,155831,354409,436188,743880,697846,488158,65185,669959,542198,40802,516572,462050,296120,277761,545811,950885,423896,716550,398761,1002956,827315,246269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]