SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502557 LIMIT 1 [ RunTime:0.000869s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502557 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246806,94451,560758,131611,682356,519272,977657,570458,579930,749099,903505,187390,342500,382732,663580,228726,942182,88682,59398,793265,477159,509673,40236,1013820,410275,991606,55907,439106,996396,1039097,88346,489507,960617,143520,167309,78271,830779,54666,579794,511479,680328,740056,366628,880131,1015440,770825,11610,981533,709699,825743,341201,757093,369591,156712,71432,721822,954531,430865,537075,628421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502557 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502557 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]