SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047473 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047473 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203352,148339,72930,364713,804487,13028,903747,940559,603299,423609,618420,754418,526343,41224,700890,737356,639481,815152,846043,308835,121271,648915,31309,469977,724426,937856,353436,852085,917300,496533,701155,347850,591657,738832,458023,93431,574070,238342,900182,807193,290012,709490,201753,142996,692928,703988,143734,648371,700911,276590,871288,651723,762056,759439,249901,550899,106699,7283,182812,292436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]