SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444451 LIMIT 1 [ RunTime:0.003013s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444451 [ RunTime:0.005380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037293,153771,869464,956804,458945,739270,265829,728599,48011,629560,1010093,524668,212440,336414,25018,676776,706316,1046342,710766,292908,764473,645229,371449,166681,131600,825119,90744,403698,220746,943913,174081,576466,631588,479439,1038096,60840,451646,1037237,403299,1044649,412595,420896,23166,770309,658672,21628,317460,480886,559950,395614,747998,842269,231012,17745,629160,17545,707579,520867,475923,561836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001325s ]