SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044453 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044453 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20489,64635,815050,915482,19263,730732,41986,276897,1042407,250745,701087,1042832,244329,561568,647655,833629,758038,134715,311033,279095,367483,22657,609823,109948,390002,12499,362510,198124,249458,406742,22576,635397,637816,358130,118343,650241,883553,236018,825820,411777,163400,769054,296506,177698,97483,26538,151934,602093,474819,943188,312112,705051,9026,857908,253950,236166,140406,405696,87214,652966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001690s ]