SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503044 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503044 [ RunTime:0.001418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001395,419858,63182,244512,270483,496591,255466,581638,759660,351320,381707,95895,66587,388779,294935,1000229,365971,215910,832949,57750,818267,283672,151648,390275,1039574,440761,1035916,297925,438115,777536,824768,208113,179872,1018717,1006766,263919,100681,695666,1047034,294748,947062,901162,1013628,751787,242525,260981,567742,167636,906446,73556,419821,6358,968516,433413,183846,682459,538804,908538,857010,159176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]