SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028670 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028670 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554543,592066,528250,346648,613853,43317,36835,174978,207118,309181,371207,317189,49506,115779,907695,310680,563179,772092,578987,834087,693593,474919,274696,712265,340818,406110,734489,655053,548711,1028727,462219,965418,529671,529096,224327,624230,740774,1019811,786771,632107,493921,780777,478065,704292,1047783,959202,608608,190557,158112,683463,478214,939820,816960,377073,272937,733161,352866,727796,830637,168218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]