SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544654 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544654 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282141,48421,20504,478045,782729,215983,894952,159091,579392,875101,691765,51769,575081,880275,216823,217070,832952,545782,233188,720249,25745,553653,521115,807482,521601,595639,240893,327343,772697,423079,511614,923374,701473,44400,872616,930396,476306,679240,811008,88754,568240,942074,956241,53012,584323,220199,364738,251838,245086,392832,699301,195316,475011,353201,36700,265402,458934,504814,21316,231153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001900s ]