SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545463 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545463 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317907,380785,266092,731505,814016,951836,228742,34514,483390,618083,618177,1037263,684800,247666,1017417,870834,813071,455564,1035255,319503,276847,2138,99774,821122,195830,659818,382976,89029,455520,412825,15595,853010,773320,140520,574124,793442,441611,364206,60693,989352,758248,992118,73350,353015,302540,105107,707026,275441,814366,851944,391681,389293,80282,497796,454606,395933,839762,373177,141925,576661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]