SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106046 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106046 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875436,607765,1011915,826152,42727,910564,396556,302593,704596,881785,165766,779868,40013,323516,916097,961750,519571,768096,609791,418808,710754,977787,764630,796018,320338,474341,864731,305258,863160,420820,267627,678979,739212,998343,365830,424978,409383,554350,746056,556471,721283,455868,508005,778443,414067,971467,975137,901727,839579,211257,295386,754159,490255,299875,272163,892660,559977,717896,296604,535391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]